Is Sony 100mm F2.8 GM Macro Worth $1500?

A few days ago, we reported that Sony would be announcing a new offering for Macro users, and today, the company has introduced the said lens: FE 100mm f2.8 Macro GM OSS. The lens is designed for E-mount cameras and includes "featuring 1.4x magnification, advanced stabilization, and intuitive handling." But, is this device something photographers should choose for their needs? Let's have a look.